﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace Chizx.DAL.View
{
    /// <summary>
    /// 数据访问类:zx_view_internship
    /// </summary>
    public partial class zx_view_internship
    {
        public zx_view_internship()
        { }
        #region  BasicMethod

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string zu_id, string zu_email, string zu_lastdate, string zu_lastip, DateTime zu_createdate, string zu_status, string zc_name, DateTime zc_createdate, int zm_id, int zd_id, string zm_name, int zc_id, DateTime zm_createdate, string zd_name, DateTime zd_createdate, int zsm_id, string zsm_type, int zsm_cid, string zsm_cname, string zsm_caddress, string zsm_applydesc, int zsm_journalnum, string zu_name, string zsm_context, string zsm_attachpath, string zsm_check, DateTime zsm_createdate, string zsm_status, string zu_pwd, int zu_sex, string zu_roles, string zu_weixin, string zu_qq, string zu_tel)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from zx_view_internship");
            strSql.Append(" where zu_id=@ChizxFDzu_id and zu_email=@ChizxFDzu_email and zu_lastdate=@ChizxFDzu_lastdate and zu_lastip=@ChizxFDzu_lastip and zu_createdate=@ChizxFDzu_createdate and zu_status=@ChizxFDzu_status and zc_name=@ChizxFDzc_name and zc_createdate=@ChizxFDzc_createdate and zm_id=@ChizxFDzm_id and zd_id=@ChizxFDzd_id and zm_name=@ChizxFDzm_name and zc_id=@ChizxFDzc_id and zm_createdate=@ChizxFDzm_createdate and zd_name=@ChizxFDzd_name and zd_createdate=@ChizxFDzd_createdate and zsm_id=@ChizxFDzsm_id and zsm_type=@ChizxFDzsm_type and zsm_cid=@ChizxFDzsm_cid and zsm_cname=@ChizxFDzsm_cname and zsm_caddress=@ChizxFDzsm_caddress and zsm_applydesc=@ChizxFDzsm_applydesc and zsm_journalnum=@ChizxFDzsm_journalnum and zu_name=@ChizxFDzu_name and zsm_context=@ChizxFDzsm_context and zsm_attachpath=@ChizxFDzsm_attachpath and zsm_check=@ChizxFDzsm_check and zsm_createdate=@ChizxFDzsm_createdate and zsm_status=@ChizxFDzsm_status and zu_pwd=@ChizxFDzu_pwd and zu_sex=@ChizxFDzu_sex and zu_roles=@ChizxFDzu_roles and zu_weixin=@ChizxFDzu_weixin and zu_qq=@ChizxFDzu_qq and zu_tel=@ChizxFDzu_tel ");
            SqlParameter[] parameters = {
					new SqlParameter("@ChizxFDzu_id", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzu_email", SqlDbType.VarChar,40),
					new SqlParameter("@ChizxFDzu_lastdate", SqlDbType.VarChar,20),
					new SqlParameter("@ChizxFDzu_lastip", SqlDbType.VarChar,20),
					new SqlParameter("@ChizxFDzu_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzu_status", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzc_name", SqlDbType.VarChar,15),
					new SqlParameter("@ChizxFDzc_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzm_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzd_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzm_name", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzc_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzm_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzd_name", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzd_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzsm_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzsm_type", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzsm_cid", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzsm_cname", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_caddress", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_applydesc", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_journalnum", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzu_name", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzsm_context", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_attachpath", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_check", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzsm_status", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzu_pwd", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_sex", SqlDbType.TinyInt,1),
					new SqlParameter("@ChizxFDzu_roles", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzu_weixin", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_qq", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_tel", SqlDbType.VarChar,30)			};
            parameters[0].Value = zu_id;
            parameters[1].Value = zu_email;
            parameters[2].Value = zu_lastdate;
            parameters[3].Value = zu_lastip;
            parameters[4].Value = zu_createdate;
            parameters[5].Value = zu_status;
            parameters[6].Value = zc_name;
            parameters[7].Value = zc_createdate;
            parameters[8].Value = zm_id;
            parameters[9].Value = zd_id;
            parameters[10].Value = zm_name;
            parameters[11].Value = zc_id;
            parameters[12].Value = zm_createdate;
            parameters[13].Value = zd_name;
            parameters[14].Value = zd_createdate;
            parameters[15].Value = zsm_id;
            parameters[16].Value = zsm_type;
            parameters[17].Value = zsm_cid;
            parameters[18].Value = zsm_cname;
            parameters[19].Value = zsm_caddress;
            parameters[20].Value = zsm_applydesc;
            parameters[21].Value = zsm_journalnum;
            parameters[22].Value = zu_name;
            parameters[23].Value = zsm_context;
            parameters[24].Value = zsm_attachpath;
            parameters[25].Value = zsm_check;
            parameters[26].Value = zsm_createdate;
            parameters[27].Value = zsm_status;
            parameters[28].Value = zu_pwd;
            parameters[29].Value = zu_sex;
            parameters[30].Value = zu_roles;
            parameters[31].Value = zu_weixin;
            parameters[32].Value = zu_qq;
            parameters[33].Value = zu_tel;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Chizx.Model.View.zx_view_internship GetModel(string zu_id, string zu_email, string zu_lastdate, string zu_lastip, DateTime zu_createdate, string zu_status, string zc_name, DateTime zc_createdate, int zm_id, int zd_id, string zm_name, int zc_id, DateTime zm_createdate, string zd_name, DateTime zd_createdate, int zsm_id, string zsm_type, int zsm_cid, string zsm_cname, string zsm_caddress, string zsm_applydesc, int zsm_journalnum, string zu_name, string zsm_context, string zsm_attachpath, string zsm_check, DateTime zsm_createdate, string zsm_status, string zu_pwd, int zu_sex, string zu_roles, string zu_weixin, string zu_qq, string zu_tel)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 zu_id,zc_id,zu_name,zu_pwd,zu_sex,zu_roles,zu_weixin,zu_qq,zu_tel,zu_email,zu_lastdate,zu_lastip,zu_createdate,zu_status,zc_name,zc_createdate,zm_id,zd_id,zm_name,zm_createdate,zd_name,zd_createdate,zsm_id,zsm_type,zsm_cid,zsm_cname,zsm_caddress,zsm_applydesc,zsm_journalnum,zsm_context,zsm_attachpath,zsm_check,zsm_createdate,zsm_status from zx_view_internship ");
            strSql.Append(" where zu_id=@ChizxFDzu_id and zu_email=@ChizxFDzu_email and zu_lastdate=@ChizxFDzu_lastdate and zu_lastip=@ChizxFDzu_lastip and zu_createdate=@ChizxFDzu_createdate and zu_status=@ChizxFDzu_status and zc_name=@ChizxFDzc_name and zc_createdate=@ChizxFDzc_createdate and zm_id=@ChizxFDzm_id and zd_id=@ChizxFDzd_id and zm_name=@ChizxFDzm_name and zc_id=@ChizxFDzc_id and zm_createdate=@ChizxFDzm_createdate and zd_name=@ChizxFDzd_name and zd_createdate=@ChizxFDzd_createdate and zsm_id=@ChizxFDzsm_id and zsm_type=@ChizxFDzsm_type and zsm_cid=@ChizxFDzsm_cid and zsm_cname=@ChizxFDzsm_cname and zsm_caddress=@ChizxFDzsm_caddress and zsm_applydesc=@ChizxFDzsm_applydesc and zsm_journalnum=@ChizxFDzsm_journalnum and zu_name=@ChizxFDzu_name and zsm_context=@ChizxFDzsm_context and zsm_attachpath=@ChizxFDzsm_attachpath and zsm_check=@ChizxFDzsm_check and zsm_createdate=@ChizxFDzsm_createdate and zsm_status=@ChizxFDzsm_status and zu_pwd=@ChizxFDzu_pwd and zu_sex=@ChizxFDzu_sex and zu_roles=@ChizxFDzu_roles and zu_weixin=@ChizxFDzu_weixin and zu_qq=@ChizxFDzu_qq and zu_tel=@ChizxFDzu_tel ");
            SqlParameter[] parameters = {
					new SqlParameter("@ChizxFDzu_id", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzu_email", SqlDbType.VarChar,40),
					new SqlParameter("@ChizxFDzu_lastdate", SqlDbType.VarChar,20),
					new SqlParameter("@ChizxFDzu_lastip", SqlDbType.VarChar,20),
					new SqlParameter("@ChizxFDzu_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzu_status", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzc_name", SqlDbType.VarChar,15),
					new SqlParameter("@ChizxFDzc_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzm_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzd_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzm_name", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzc_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzm_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzd_name", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzd_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzsm_id", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzsm_type", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzsm_cid", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzsm_cname", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_caddress", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_applydesc", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_journalnum", SqlDbType.Int,4),
					new SqlParameter("@ChizxFDzu_name", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzsm_context", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_attachpath", SqlDbType.VarChar,50),
					new SqlParameter("@ChizxFDzsm_check", SqlDbType.NText),
					new SqlParameter("@ChizxFDzsm_createdate", SqlDbType.DateTime),
					new SqlParameter("@ChizxFDzsm_status", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzu_pwd", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_sex", SqlDbType.TinyInt,1),
					new SqlParameter("@ChizxFDzu_roles", SqlDbType.Char,2),
					new SqlParameter("@ChizxFDzu_weixin", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_qq", SqlDbType.VarChar,30),
					new SqlParameter("@ChizxFDzu_tel", SqlDbType.VarChar,30)			};
            parameters[0].Value = zu_id;
            parameters[1].Value = zu_email;
            parameters[2].Value = zu_lastdate;
            parameters[3].Value = zu_lastip;
            parameters[4].Value = zu_createdate;
            parameters[5].Value = zu_status;
            parameters[6].Value = zc_name;
            parameters[7].Value = zc_createdate;
            parameters[8].Value = zm_id;
            parameters[9].Value = zd_id;
            parameters[10].Value = zm_name;
            parameters[11].Value = zc_id;
            parameters[12].Value = zm_createdate;
            parameters[13].Value = zd_name;
            parameters[14].Value = zd_createdate;
            parameters[15].Value = zsm_id;
            parameters[16].Value = zsm_type;
            parameters[17].Value = zsm_cid;
            parameters[18].Value = zsm_cname;
            parameters[19].Value = zsm_caddress;
            parameters[20].Value = zsm_applydesc;
            parameters[21].Value = zsm_journalnum;
            parameters[22].Value = zu_name;
            parameters[23].Value = zsm_context;
            parameters[24].Value = zsm_attachpath;
            parameters[25].Value = zsm_check;
            parameters[26].Value = zsm_createdate;
            parameters[27].Value = zsm_status;
            parameters[28].Value = zu_pwd;
            parameters[29].Value = zu_sex;
            parameters[30].Value = zu_roles;
            parameters[31].Value = zu_weixin;
            parameters[32].Value = zu_qq;
            parameters[33].Value = zu_tel;

            Chizx.Model.View.zx_view_internship model = new Chizx.Model.View.zx_view_internship();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Chizx.Model.View.zx_view_internship DataRowToModel(DataRow row)
        {
            Chizx.Model.View.zx_view_internship model = new Chizx.Model.View.zx_view_internship();
            if (row != null)
            {
                if (row["zu_id"] != null)
                {
                    model.zu_id = row["zu_id"].ToString();
                }
                if (row["zc_id"] != null && row["zc_id"].ToString() != "")
                {
                    model.zc_id = int.Parse(row["zc_id"].ToString());
                }
                if (row["zu_name"] != null)
                {
                    model.zu_name = row["zu_name"].ToString();
                }
                if (row["zu_pwd"] != null)
                {
                    model.zu_pwd = row["zu_pwd"].ToString();
                }
                if (row["zu_sex"] != null && row["zu_sex"].ToString() != "")
                {
                    model.zu_sex = int.Parse(row["zu_sex"].ToString());
                }
                if (row["zu_roles"] != null)
                {
                    model.zu_roles = row["zu_roles"].ToString();
                }
                if (row["zu_weixin"] != null)
                {
                    model.zu_weixin = row["zu_weixin"].ToString();
                }
                if (row["zu_qq"] != null)
                {
                    model.zu_qq = row["zu_qq"].ToString();
                }
                if (row["zu_tel"] != null)
                {
                    model.zu_tel = row["zu_tel"].ToString();
                }
                if (row["zu_email"] != null)
                {
                    model.zu_email = row["zu_email"].ToString();
                }
                if (row["zu_lastdate"] != null)
                {
                    model.zu_lastdate = row["zu_lastdate"].ToString();
                }
                if (row["zu_lastip"] != null)
                {
                    model.zu_lastip = row["zu_lastip"].ToString();
                }
                if (row["zu_createdate"] != null && row["zu_createdate"].ToString() != "")
                {
                    model.zu_createdate = DateTime.Parse(row["zu_createdate"].ToString());
                }
                if (row["zu_status"] != null)
                {
                    model.zu_status = row["zu_status"].ToString();
                }
                if (row["zc_name"] != null)
                {
                    model.zc_name = row["zc_name"].ToString();
                }
                if (row["zc_createdate"] != null && row["zc_createdate"].ToString() != "")
                {
                    model.zc_createdate = DateTime.Parse(row["zc_createdate"].ToString());
                }
                if (row["zm_id"] != null && row["zm_id"].ToString() != "")
                {
                    model.zm_id = int.Parse(row["zm_id"].ToString());
                }
                if (row["zd_id"] != null && row["zd_id"].ToString() != "")
                {
                    model.zd_id = int.Parse(row["zd_id"].ToString());
                }
                if (row["zm_name"] != null)
                {
                    model.zm_name = row["zm_name"].ToString();
                }
                if (row["zm_createdate"] != null && row["zm_createdate"].ToString() != "")
                {
                    model.zm_createdate = DateTime.Parse(row["zm_createdate"].ToString());
                }
                if (row["zd_name"] != null)
                {
                    model.zd_name = row["zd_name"].ToString();
                }
                if (row["zd_createdate"] != null && row["zd_createdate"].ToString() != "")
                {
                    model.zd_createdate = DateTime.Parse(row["zd_createdate"].ToString());
                }
                if (row["zsm_id"] != null && row["zsm_id"].ToString() != "")
                {
                    model.zsm_id = int.Parse(row["zsm_id"].ToString());
                }
                if (row["zsm_type"] != null)
                {
                    model.zsm_type = row["zsm_type"].ToString();
                }
                if (row["zsm_cid"] != null && row["zsm_cid"].ToString() != "")
                {
                    model.zsm_cid = int.Parse(row["zsm_cid"].ToString());
                }
                if (row["zsm_cname"] != null)
                {
                    model.zsm_cname = row["zsm_cname"].ToString();
                }
                if (row["zsm_caddress"] != null)
                {
                    model.zsm_caddress = row["zsm_caddress"].ToString();
                }
                if (row["zsm_applydesc"] != null)
                {
                    model.zsm_applydesc = row["zsm_applydesc"].ToString();
                }
                if (row["zsm_journalnum"] != null && row["zsm_journalnum"].ToString() != "")
                {
                    model.zsm_journalnum = int.Parse(row["zsm_journalnum"].ToString());
                }
                if (row["zsm_context"] != null)
                {
                    model.zsm_context = row["zsm_context"].ToString();
                }
                if (row["zsm_attachpath"] != null)
                {
                    model.zsm_attachpath = row["zsm_attachpath"].ToString();
                }
                if (row["zsm_check"] != null)
                {
                    model.zsm_check = row["zsm_check"].ToString();
                }
                if (row["zsm_createdate"] != null && row["zsm_createdate"].ToString() != "")
                {
                    model.zsm_createdate = DateTime.Parse(row["zsm_createdate"].ToString());
                }
                if (row["zsm_status"] != null)
                {
                    model.zsm_status = row["zsm_status"].ToString();
                }
            }
            return model;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select zu_id,zc_id,zu_name,zu_pwd,zu_sex,zu_roles,zu_weixin,zu_qq,zu_tel,zu_email,zu_lastdate,zu_lastip,zu_createdate,zu_status,zc_name,zc_createdate,zm_id,zd_id,zm_name,zm_createdate,zd_name,zd_createdate,zsm_id,zsm_type,zsm_cid,zsm_cname,zsm_caddress,zsm_applydesc,zsm_journalnum,zsm_context,zsm_attachpath,zsm_check,zsm_createdate,zsm_status ");
            strSql.Append(" FROM zx_view_internship ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public DataSet GetList(int Top, string strWhere, string filedOrder)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ");
            if (Top > 0)
            {
                strSql.Append(" top " + Top.ToString());
            }
            strSql.Append(" zu_id,zc_id,zu_name,zu_pwd,zu_sex,zu_roles,zu_weixin,zu_qq,zu_tel,zu_email,zu_lastdate,zu_lastip,zu_createdate,zu_status,zc_name,zc_createdate,zm_id,zd_id,zm_name,zm_createdate,zd_name,zd_createdate,zsm_id,zsm_type,zsm_cid,zsm_cname,zsm_caddress,zsm_applydesc,zsm_journalnum,zsm_context,zsm_attachpath,zsm_check,zsm_createdate,zsm_status ");
            strSql.Append(" FROM zx_view_internship ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" order by " + filedOrder);
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) FROM zx_view_internship ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                strSql.Append("order by T.zu_tel desc");
            }
            strSql.Append(")AS Row, T.*  from zx_view_internship T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetList(int PageSize,int PageIndex,string strWhere)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@ChizxFDtblName", SqlDbType.VarChar, 255),
                    new SqlParameter("@ChizxFDfldName", SqlDbType.VarChar, 255),
                    new SqlParameter("@ChizxFDPageSize", SqlDbType.Int),
                    new SqlParameter("@ChizxFDPageIndex", SqlDbType.Int),
                    new SqlParameter("@ChizxFDIsReCount", SqlDbType.Bit),
                    new SqlParameter("@ChizxFDOrderType", SqlDbType.Bit),
                    new SqlParameter("@ChizxFDstrWhere", SqlDbType.VarChar,1000),
                    };
            parameters[0].Value = "zx_view_internship";
            parameters[1].Value = "zu_tel";
            parameters[2].Value = PageSize;
            parameters[3].Value = PageIndex;
            parameters[4].Value = 0;
            parameters[5].Value = 0;
            parameters[6].Value = strWhere;	
            return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
        }*/

        #endregion  BasicMethod
        #region  ExtensionMethod

        #endregion  ExtensionMethod
    }
}

